Mod Name / Version - Postlist Last Post By for 6.2 <br /> <br />Description - Shows the "Last Post By" information on the postlist page. To save queries, I chose to store the username... so the name won't be accurate if a user has changed their display name. Since this is only stored for the last post, I figured it was worth the savings in queries. <br /> <br />Pre-requisites - none <br /> <br />Author - JustDave from www.chattersonline.com original author <br />   Updated for 6.2 by JoshPet of www.joshuapettit.com <br /> <br />Credits - Allen Ayres for testing of original version <br /> <br />Files Altered - <br />   postlist.php (threads directory) <br />   postlist.tmpl (threads directory) <br />   addpost.php (threads directory) <br />   doapproveposts.php (admin directory) <br />   viewunapproved.php (admin directory) <br />   deletepost.php (threads directory) <br /> <br />Database Altered - Yes. 3 fields (B_Last_Number, B_Last_Name, and B_Last_Approved) added to w3t_Posts table. <br /> <br />New Files - none <br /> <br />Any other info - JustDave gets a bulk of the credit here, I just adapted for 6.2. <img src="/forum/images/graemlins/wink.gif" alt="" /> <br /> <br />Last Update: January 19, 2003

thank you <img src="/forum/images/graemlins/smile.gif" alt="" />

You are welcome. Sometimes I need a nudge to get stuff onto my plate.<br /><br />JustDave my know a better way to do this. I stored the username for last post to save queries. So it won't change when the name changes, but it changes as soon as there's another post in that thread anyway, so for my board, I didn't see it as a big issue. <br /><br />The link still works... and as we have discovered here, once the name change thing gets tested out, it's doesn't happen that frequently. <br /><br />But otherwise it required another query per thread being viewed. Probably could have been done like the [Re: Username] thing with an array, but that one escapes me at my current coding level. <img src="/forum/images/graemlins/smile.gif" alt="" />

it escapes me at my next 2 coding levels <img src="/forum/images/graemlins/wink.gif" alt="" />

LOL - I'm gaining on it. But I didn't sleep last night (bad new habit of skipping sleep on Saturday night <img src="/forum/images/graemlins/crazy.gif" alt="" />) so I can't even comprehend it right now. <img src="/forum/images/graemlins/tongue.gif" alt="" />

Yeah I was stopped at that point on this. I need to set that same array setup on this to get the usernames from their numbers. I'll update your instructions when I do this. Thanks for bringing it up to speed for 6.2 <img src="/forum/images/graemlins/smile.gif" alt="" />

Is deletepost.php working for you? It must be late but I can't see what I may have done wrong... lol It's something simple so it's alluding me right now. I think I'm looking way to deep. LoL <img src="/forum/images/graemlins/crazy.gif" alt="" />

It was working for me... I'll send you my deletepost and you can compare. <img src="/forum/images/graemlins/tongue.gif" alt="" />

Thanks but I think it's do to my own coding mess at the moment... LoL I'll get my stuff cleaned up.

Test <img src="/forum/images/graemlins/wink.gif" alt="" />

Ok at the cost of one query in postlist.php and saving 1 query in the other scripts I have this working with user numbers. yay <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br />I'll append the instructions sometime today. <img src="/forum/images/graemlins/smile.gif" alt="" />

Hey, <br />I just noticed both on my board and here (since installing this) that my new post rows aren't ligthing up.<br /><br />Can't think of why this would mess that up.... can you?<br /><br /><img src="/forum/images/graemlins/confused.gif" alt="" /><br /><br />Or is this just a mac thing? <img src="/forum/images/graemlins/tongue.gif" alt="" /><br /><br />It doesn't mess with classes in the postlist.tmpl file.

hmmmm.... I hadn't noticed. I'll look things over and see what may be the cause. <img src="/forum/images/graemlins/smile.gif" alt="" />

Ok I finished cleaning things up a bit. There's a new create/alter table script as well so that old installs can update and use the user numbers.<br /><br />Will zip and post shortly. <img src="/forum/images/graemlins/smile.gif" alt="" />

You got the post lines working again. <img src="/forum/images/graemlins/grin.gif" alt="" /><br /><br />Yeah. Well I tried and came close.... as usual. Always need JustDave around to finalize things. <img src="/forum/images/graemlins/wink.gif" alt="" /><br /><br />Thanks Dave. <img src="/forum/images/graemlins/smile.gif" alt="" />

Your welcome <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br />I just updated the zip. There's a new createlastpostfields-6.2.php script everyone will need to run. For those that are upgrading this will clean out the B_Last_Name field and change it's type to INT(9).<br /><br />You'll need to be logged in as an admin and the forums need to be closed to access the script.

Thanks for this Josh & Dave - will be installing today <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br />

Dave - <br />I thought I could fix this on my own...but the way you've thrown all the user numbers into an array... it confuses me. <img src="/forum/images/graemlins/crazy.gif" alt="" /><br /><br />Anyway... need to add a clause if the user number is 1, then it needs to fetch the anon name from he post table. Otherwise the last posts (if anon) show up as ***DONOTDELETE*** <img src="/forum/images/graemlins/tongue.gif" alt="" /><br /><br />Ugh.

JustDave, i installed this one also and it works very well.<br />But i have a question regarding the field B_Last_Approved.<br />What's the different to B_Approved?<br />I think it stores exactly the same values or did i get something wrong?

The B_Last_Approved is 'yes' by default just as is B_Approved. If a user replies to a thread and their reply needs approval then it will not be displayed in the "Last Post By" information untill it is approved. <img src="/forum/images/graemlins/smile.gif" alt="" />